/*
 Navicat Premium Data Transfer

 Source Server         : ladmin_com
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 120.79.235.236:3306
 Source Schema         : ladmin_com

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 19/05/2022 18:18:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for system_auth
-- ----------------------------
DROP TABLE IF EXISTS `system_auth`;
CREATE TABLE `system_auth` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT '' COMMENT '权限名称',
  `utype` varchar(50) DEFAULT '' COMMENT '身份权限',
  `desc` varchar(500) DEFAULT '' COMMENT '备注说明',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序权重',
  `status` tinyint(1) DEFAULT '1' COMMENT '权限状态(1使用,0禁用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_auth_status` (`status`) USING BTREE,
  KEY `idx_system_auth_title` (`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统-权限';

-- ----------------------------
-- Records of system_auth
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_auth_node
-- ----------------------------
DROP TABLE IF EXISTS `system_auth_node`;
CREATE TABLE `system_auth_node` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `auth` bigint(20) DEFAULT '0' COMMENT '角色',
  `node` varchar(200) DEFAULT '' COMMENT '节点',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_auth_auth` (`auth`) USING BTREE,
  KEY `idx_system_auth_node` (`node`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统-授权';

-- ----------------------------
-- Records of system_auth_node
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_base
-- ----------------------------
DROP TABLE IF EXISTS `system_base`;
CREATE TABLE `system_base` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT '' COMMENT '数据类型',
  `code` varchar(50) DEFAULT '' COMMENT '数据代码',
  `name` varchar(200) DEFAULT '' COMMENT '数据名称',
  `content` text COMMENT '数据内容',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序权重',
  `status` tinyint(1) DEFAULT '1' COMMENT '数据状态(0禁用,1启动)',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '删除状态(0正常,1已删)',
  `deleted_at` varchar(20) DEFAULT '' COMMENT '删除时间',
  `deleted_by` bigint(20) DEFAULT '0' COMMENT '删除用户',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_base_type` (`type`) USING BTREE,
  KEY `idx_system_base_code` (`code`) USING BTREE,
  KEY `idx_system_base_name` (`name`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统-字典';

-- ----------------------------
-- Records of system_base
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT '' COMMENT '配置分类',
  `name` varchar(100) DEFAULT '' COMMENT '配置名称',
  `value` varchar(2048) DEFAULT '' COMMENT '配置内容',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_config_type` (`type`) USING BTREE,
  KEY `idx_system_config_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统-配置';

-- ----------------------------
-- Records of system_config
-- ----------------------------
BEGIN;
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (1, 'base', 'app_name', 'Ladmin');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (2, 'base', 'app_version', 'v2');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (3, 'base', 'beian', '');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (4, 'base', 'login_image', '');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (5, 'base', 'login_name', '系统管理');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (6, 'base', 'miitbeian', '');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (7, 'base', 'site_copy', '©版权所有 2014-2022 Ladmin.cn');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (8, 'base', 'site_host', 'http://www.ladmin.com');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (9, 'base', 'site_icon', 'http://www.ladmin.com/favicon.ico');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (10, 'base', 'site_name', 'Ladmin');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (11, 'base', 'site_theme', 'black-1');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (12, 'base', 'xpath', 'admin');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (13, 'storage', 'alioss_http_protocol', 'http');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (14, 'storage', 'allow_exts', 'doc,gif,ico,jpg,mp3,mp4,p12,pem,png,rar,xls,xlsx');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (15, 'storage', 'link_type', 'none');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (16, 'storage', 'local_http_domain', '');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (17, 'storage', 'local_http_protocol', 'follow');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (18, 'storage', 'name_type', 'xmd5');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (19, 'storage', 'qiniu_http_protocol', 'http');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (20, 'storage', 'type', 'local');
INSERT INTO `system_config` (`id`, `type`, `name`, `value`) VALUES (21, 'wechat', 'type', 'api');
COMMIT;

-- ----------------------------
-- Table structure for system_data
-- ----------------------------
DROP TABLE IF EXISTS `system_data`;
CREATE TABLE `system_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '配置名',
  `value` longtext COMMENT '配置值',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_data_name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统-数据';

-- ----------------------------
-- Records of system_data
-- ----------------------------
BEGIN;
INSERT INTO `system_data` (`id`, `name`, `value`) VALUES (1, 'UserData_10000', 'a:1:{s:10:\"site_theme\";s:7:\"black-1\";}');
COMMIT;

-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) DEFAULT '0' COMMENT '上级ID',
  `title` varchar(100) DEFAULT '' COMMENT '菜单名称',
  `icon` varchar(100) DEFAULT '' COMMENT '菜单图标',
  `node` varchar(100) DEFAULT '' COMMENT '节点代码',
  `url` varchar(400) DEFAULT '' COMMENT '链接节点',
  `params` varchar(500) DEFAULT '' COMMENT '链接参数',
  `target` varchar(20) DEFAULT '_self' COMMENT '打开方式',
  `sort` int(11) DEFAULT '0' COMMENT '排序权重',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_menu_status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统-菜单';

-- ----------------------------
-- Records of system_menu
-- ----------------------------
BEGIN;
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (1, 0, '系统管理', '', '', '#', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (2, 1, '系统配置', '', '', '#', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (3, 2, '系统参数配置', 'layui-icon layui-icon-set', '', 'admin/config/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (4, 2, '系统任务管理', 'layui-icon layui-icon-log', '', 'admin/queue/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (5, 2, '系统日志管理', 'layui-icon layui-icon-form', '', 'admin/oplog/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (6, 2, '数据字典管理', 'layui-icon layui-icon-code-circle', 'admin/base/index', 'admin/base/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (7, 2, '系统菜单管理', 'layui-icon layui-icon-layouts', '', 'admin/menu/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (8, 1, '权限管理', '', '', '#', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (9, 8, '访问权限管理', 'layui-icon layui-icon-vercode', '', 'admin/auth/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
INSERT INTO `system_menu` (`id`, `pid`, `title`, `icon`, `node`, `url`, `params`, `target`, `sort`, `status`, `create_at`) VALUES (10, 8, '系统用户管理', 'layui-icon layui-icon-username', '', 'admin/user/index', '', '_self', 0, 1, '2022-03-04 20:34:41');
COMMIT;

-- ----------------------------
-- Table structure for system_oplog
-- ----------------------------
DROP TABLE IF EXISTS `system_oplog`;
CREATE TABLE `system_oplog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `node` varchar(200) NOT NULL DEFAULT '' COMMENT '当前操作节点',
  `geoip` varchar(15) NOT NULL DEFAULT '' COMMENT '操作者IP地址',
  `action` varchar(200) NOT NULL DEFAULT '' COMMENT '操作行为名称',
  `content` varchar(1024) NOT NULL DEFAULT '' COMMENT '操作内容描述',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人用户名',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统-日志';

-- ----------------------------
-- Records of system_oplog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_queue
-- ----------------------------
DROP TABLE IF EXISTS `system_queue`;
CREATE TABLE `system_queue` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL DEFAULT '' COMMENT '任务编号',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务名称',
  `command` varchar(500) DEFAULT '' COMMENT '执行指令',
  `exec_pid` bigint(20) DEFAULT '0' COMMENT '执行进程',
  `exec_data` longtext COMMENT '执行参数',
  `exec_time` bigint(20) DEFAULT '0' COMMENT '执行时间',
  `exec_desc` varchar(500) DEFAULT '' COMMENT '执行描述',
  `enter_time` decimal(20,4) DEFAULT '0.0000' COMMENT '开始时间',
  `outer_time` decimal(20,4) DEFAULT '0.0000' COMMENT '结束时间',
  `loops_time` bigint(20) DEFAULT '0' COMMENT '循环时间',
  `attempts` bigint(20) DEFAULT '0' COMMENT '执行次数',
  `rscript` tinyint(1) DEFAULT '1' COMMENT '任务类型(0单例,1多例)',
  `status` tinyint(1) DEFAULT '1' COMMENT '任务状态(1新任务,2处理中,3成功,4失败)',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_queue_code` (`code`) USING BTREE,
  KEY `idx_system_queue_title` (`title`) USING BTREE,
  KEY `idx_system_queue_status` (`status`) USING BTREE,
  KEY `idx_system_queue_rscript` (`rscript`) USING BTREE,
  KEY `idx_system_queue_create_at` (`create_at`) USING BTREE,
  KEY `idx_system_queue_exec_time` (`exec_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统-任务';

-- ----------------------------
-- Records of system_queue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `usertype` varchar(20) DEFAULT '' COMMENT '用户类型',
  `username` varchar(50) DEFAULT '' COMMENT '用户账号',
  `password` varchar(32) DEFAULT '' COMMENT '用户密码',
  `nickname` varchar(50) DEFAULT '' COMMENT '用户昵称',
  `headimg` varchar(255) DEFAULT '' COMMENT '头像地址',
  `authorize` varchar(255) DEFAULT '' COMMENT '权限授权',
  `contact_qq` varchar(20) DEFAULT '' COMMENT '联系QQ',
  `contact_mail` varchar(20) DEFAULT '' COMMENT '联系邮箱',
  `contact_phone` varchar(20) DEFAULT '' COMMENT '联系手机',
  `login_ip` varchar(255) DEFAULT '' COMMENT '登录地址',
  `login_at` varchar(20) DEFAULT '' COMMENT '登录时间',
  `login_num` bigint(20) DEFAULT '0' COMMENT '登录次数',
  `describe` varchar(255) DEFAULT '' COMMENT '备注说明',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态(0禁用,1启用)',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序权重',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '删除(1删除,0未删)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_user_status` (`status`) USING BTREE,
  KEY `idx_system_user_username` (`username`) USING BTREE,
  KEY `idx_system_user_deleted` (`is_deleted`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统-用户';

-- ----------------------------
-- Records of system_user
-- ----------------------------
BEGIN;
INSERT INTO `system_user` (`id`, `usertype`, `username`, `password`, `nickname`, `headimg`, `authorize`, `contact_qq`, `contact_mail`, `contact_phone`, `login_ip`, `login_at`, `login_num`, `describe`, `status`, `sort`, `is_deleted`, `create_at`) VALUES (10000, '', 'admin', '21232f297a57a5a743894a0e4a801fc3', '系统管理员', '', ',,', '', '', '', '172.17.0.1', '2022-05-19 15:53:33', 11, '', 1, 1, 0, '2022-03-08 10:00:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
